Instructor

EntityType | Independent
Logical Entity Name | Instructor
Default Table Name | AdTeacher
Logical Only | YES
Owner |
Definition |
Note |

Instructor Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Code |  | VARCHAR(255) | NO |
Position |  | VARCHAR(50) | YES |
CampusGroupId |  | INTEGER | YES |
LastName |  | VARCHAR(25) | YES |
FirstName |  | VARCHAR(25) | YES |
Addr1 |  | VARCHAR(255) | YES |
Addr2 |  | VARCHAR(35) | YES |
City |  | VARCHAR(25) | YES |
State |  | CHAR(2) | YES |
Zip |  | CHAR(10) | YES |
Phone |  | CHAR(16) | YES |
IsActive |  | BIT | YES |
Userid |  | INTEGER | YES |
DateAdded |  | DATETIME | YES |
DateLstMod |  | DATETIME | YES |
Name |  | VARCHAR(52) | YES |
InstructorId |  | INTEGER | YES |
StaffId |  | INTEGER | YES |
SSN |  | CHAR(11) | YES |
ClassSectionId |  | INTEGER | NO |
ClassSectionMeetingDateId |  | INTEGER | YES |
ClassSectionSecondaryInstructorId |  | INTEGER | NO |

Instructor Keys

Key Name | Key Type | Keys

Instructor Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
ClassSection | Non-Identifying | One To Zero or More |  |  |  | ClassSectionId | NO
ClassSectionMeetingDate | Non-Identifying | Zero or One to Zero or More |  |  |  | ClassSectionMeetingDateId | NO
ClassSectionSecondaryInstructor | Non-Identifying | One To Zero or More |  |  |  | ClassSectionSecondaryInstructorId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
ClassSection | Non-Identifying | One To Zero or More |  |  |  |  | NO
InstructorCourseAssociation | Non-Identifying | One To Zero or More |  |  |  |  | NO
InstructorAssignedAttribute | Non-Identifying | One To Zero or More |  |  |  |  | NO
InstructorAssignedAttribute | Non-Identifying | One To Zero or More |  |  |  |  | NO
InstructorCourseAssociation | Non-Identifying | One To Zero or More |  |  |  |  | NO

Instructor Check Constraints

Check Constraint Name | CheckConstraint

Instructor Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical Instructor | NO |  |  |
Physical (Microsoft SQL Server) Does Not Exist | NO |  |  |

Instructor Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ClassScheduling

Instructor Data Movement Rules

Name | Type | Rule Text/Value